Summary data stasiun Huairou

Dataset statistics

Number of variables	18
Number of observations	35064
Missing cells	7485
Missing cells (%)	1.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.8 MiB
Average record size in memory	144.0 B

Variable types

Numeric	15
Categorical	3

Alerts

`station` has constant value ""	Constant
`CO` is highly overall correlated with `NO2` and 3 other fields	High correlation
`DEWP` is highly overall correlated with `PRES` and 1 other fields	High correlation
`NO2` is highly overall correlated with `CO` and 3 other fields	High correlation
`No` is highly overall correlated with `year`	High correlation
`O3` is highly overall correlated with `TEMP`	High correlation
`PM10` is highly overall correlated with `CO` and 3 other fields	High correlation
`PM2.5` is highly overall correlated with `CO` and 3 other fields	High correlation
`PRES` is highly overall correlated with `DEWP` and 1 other fields	High correlation
`SO2` is highly overall correlated with `CO` and 3 other fields	High correlation
`TEMP` is highly overall correlated with `DEWP` and 2 other fields	High correlation
`year` is highly overall correlated with `No`	High correlation
`PM2.5` has 953 (2.7%) missing values	Missing
`PM10` has 777 (2.2%) missing values	Missing
`SO2` has 980 (2.8%) missing values	Missing
`NO2` has 1639 (4.7%) missing values	Missing
`CO` has 1422 (4.1%) missing values	Missing
`O3` has 1151 (3.3%) missing values	Missing
`RAIN` is highly skewed (γ1 = 26.5432332)	Skewed
`No` is uniformly distributed	Uniform
`No` has unique values	Unique
`hour` has 1461 (4.2%) zeros	Zeros
`RAIN` has 33518 (95.6%) zeros	Zeros

Reproduction

Analysis started	2024-03-08 05:12:22.056855
Analysis finished	2024-03-08 05:13:10.353492
Duration	48.3 seconds
Software version	ydata-profiling vv4.6.5
Download configuration	config.json

No
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	35064
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17532.5

Minimum	1
Maximum	35064
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1754.15
Q1	8766.75
median	17532.5
Q3	26298.25
95-th percentile	33310.85
Maximum	35064
Range	35063
Interquartile range (IQR)	17531.5

Descriptive statistics

Standard deviation	10122.249
Coefficient of variation (CV)	0.57734204
Kurtosis	-1.2
Mean	17532.5
Median Absolute Deviation (MAD)	8766
Skewness	0
Sum	6.1475958 × 10⁸
Variance	1.0245993 × 10⁸
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
23379	1	< 0.1%
23373	1	< 0.1%
23374	1	< 0.1%
23375	1	< 0.1%
23376	1	< 0.1%
23377	1	< 0.1%
23378	1	< 0.1%
23380	1	< 0.1%
23422	1	< 0.1%
Other values (35054)	35054	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
35064	1	< 0.1%
35063	1	< 0.1%
35062	1	< 0.1%
35061	1	< 0.1%
35060	1	< 0.1%
35059	1	< 0.1%
35058	1	< 0.1%
35057	1	< 0.1%
35056	1	< 0.1%
35055	1	< 0.1%

year
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	274.1 KiB

2016	8784
2014	8760
2015	8760
2013	7344
2017	1416

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	140256
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2013
2nd row	2013
3rd row	2013
4th row	2013
5th row	2013

Common Values

Value	Count	Frequency (%)
2016	8784	25.1%
2014	8760	25.0%
2015	8760	25.0%
2013	7344	20.9%
2017	1416	4.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2016	8784	25.1%
2014	8760	25.0%
2015	8760	25.0%
2013	7344	20.9%
2017	1416	4.0%

Most occurring characters

Value	Count	Frequency (%)
2	35064	25.0%
0	35064	25.0%
1	35064	25.0%
6	8784	6.3%
4	8760	6.2%
5	8760	6.2%
3	7344	5.2%
7	1416	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	140256	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	35064	25.0%
0	35064	25.0%
1	35064	25.0%
6	8784	6.3%
4	8760	6.2%
5	8760	6.2%
3	7344	5.2%
7	1416	1.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	140256	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	35064	25.0%
0	35064	25.0%
1	35064	25.0%
6	8784	6.3%
4	8760	6.2%
5	8760	6.2%
3	7344	5.2%
7	1416	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140256	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	35064	25.0%
0	35064	25.0%
1	35064	25.0%
6	8784	6.3%
4	8760	6.2%
5	8760	6.2%
3	7344	5.2%
7	1416	1.0%

month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5229295

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4487524
Coefficient of variation (CV)	0.52871219
Kurtosis	-1.2080577
Mean	6.5229295
Median Absolute Deviation (MAD)	3
Skewness	-0.0092942217
Sum	228720
Variance	11.893893
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	2976	8.5%
5	2976	8.5%
7	2976	8.5%
8	2976	8.5%
10	2976	8.5%
12	2976	8.5%
1	2976	8.5%
4	2880	8.2%
6	2880	8.2%
9	2880	8.2%
Other values (2)	5592	15.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2976	8.5%
2	2712	7.7%
3	2976	8.5%
4	2880	8.2%
5	2976	8.5%
6	2880	8.2%
7	2976	8.5%
8	2976	8.5%
9	2880	8.2%
10	2976	8.5%

Value	Count	Frequency (%)
12	2976	8.5%
11	2880	8.2%
10	2976	8.5%
9	2880	8.2%
8	2976	8.5%
7	2976	8.5%
6	2880	8.2%
5	2976	8.5%
4	2880	8.2%
3	2976	8.5%

day
Real number (ℝ)

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.729637

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.8002175
Coefficient of variation (CV)	0.55946729
Kurtosis	-1.1940295
Mean	15.729637
Median Absolute Deviation (MAD)	8
Skewness	0.0067598056
Sum	551544
Variance	77.443829
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	1152	3.3%
2	1152	3.3%
28	1152	3.3%
27	1152	3.3%
26	1152	3.3%
25	1152	3.3%
24	1152	3.3%
23	1152	3.3%
22	1152	3.3%
21	1152	3.3%
Other values (21)	23544	67.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1152	3.3%
2	1152	3.3%
3	1152	3.3%
4	1152	3.3%
5	1152	3.3%
6	1152	3.3%
7	1152	3.3%
8	1152	3.3%
9	1152	3.3%
10	1152	3.3%

Value	Count	Frequency (%)
31	672	1.9%
30	1056	3.0%
29	1080	3.1%
28	1152	3.3%
27	1152	3.3%
26	1152	3.3%
25	1152	3.3%
24	1152	3.3%
23	1152	3.3%
22	1152	3.3%

hour
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.5

Minimum	0
Maximum	23
Zeros	1461
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5.75
median	11.5
Q3	17.25
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	11.5

Descriptive statistics

Standard deviation	6.9222853
Coefficient of variation (CV)	0.60193785
Kurtosis	-1.2041745
Mean	11.5
Median Absolute Deviation (MAD)	6
Skewness	0
Sum	403236
Variance	47.918033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	1461	4.2%
1	1461	4.2%
22	1461	4.2%
21	1461	4.2%
20	1461	4.2%
19	1461	4.2%
18	1461	4.2%
17	1461	4.2%
16	1461	4.2%
15	1461	4.2%
Other values (14)	20454	58.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1461	4.2%
1	1461	4.2%
2	1461	4.2%
3	1461	4.2%
4	1461	4.2%
5	1461	4.2%
6	1461	4.2%
7	1461	4.2%
8	1461	4.2%
9	1461	4.2%

Value	Count	Frequency (%)
23	1461	4.2%
22	1461	4.2%
21	1461	4.2%
20	1461	4.2%
19	1461	4.2%
18	1461	4.2%
17	1461	4.2%
16	1461	4.2%
15	1461	4.2%
14	1461	4.2%

PM2.5
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	479
Distinct (%)	1.4%
Missing	953
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%
Mean	69.626367

Minimum	2
Maximum	762
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	2
5-th percentile	5
Q1	17
median	47
Q3	98
95-th percentile	216
Maximum	762
Range	760
Interquartile range (IQR)	81

Descriptive statistics

Standard deviation	71.224916
Coefficient of variation (CV)	1.022959
Kurtosis	5.1869457
Mean	69.626367
Median Absolute Deviation (MAD)	34
Skewness	1.922288
Sum	2375025
Variance	5072.9887
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	1092	3.1%
8	625	1.8%
9	605	1.7%
7	599	1.7%
10	599	1.7%
12	594	1.7%
14	569	1.6%
13	564	1.6%
11	547	1.6%
6	535	1.5%
Other values (469)	27782	79.2%
(Missing)	953	2.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	2	< 0.1%
3	1092	3.1%
4	376	1.1%
5	451	1.3%
6	535	1.5%
7	599	1.7%
8	625	1.8%
9	605	1.7%
10	599	1.7%
11	547	1.6%

Value	Count	Frequency (%)
762	1	< 0.1%
683	1	< 0.1%
659	1	< 0.1%
559	1	< 0.1%
558	1	< 0.1%
556	1	< 0.1%
551	1	< 0.1%
545	1	< 0.1%
544	1	< 0.1%
538	1	< 0.1%

PM10
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	556
Distinct (%)	1.6%
Missing	777
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%
Mean	91.48269

Minimum	2
Maximum	993
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	2
5-th percentile	8
Q1	28
median	69
Q3	131
95-th percentile	251
Maximum	993
Range	991
Interquartile range (IQR)	103

Descriptive statistics

Standard deviation	83.289578
Coefficient of variation (CV)	0.91044085
Kurtosis	6.9383673
Mean	91.48269
Median Absolute Deviation (MAD)	46
Skewness	1.9083736
Sum	3136667
Variance	6937.1538
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	641	1.8%
5	528	1.5%
14	399	1.1%
12	380	1.1%
10	379	1.1%
17	370	1.1%
16	366	1.0%
9	365	1.0%
19	363	1.0%
15	359	1.0%
Other values (546)	30137	85.9%
(Missing)	777	2.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	3	< 0.1%
3	76	0.2%
4	21	0.1%
5	528	1.5%
6	641	1.8%
7	278	0.8%
8	348	1.0%
9	365	1.0%
9.8	1	< 0.1%
10	379	1.1%

Value	Count	Frequency (%)
993	1	< 0.1%
991	1	< 0.1%
973	2	< 0.1%
948	1	< 0.1%
922	1	< 0.1%
917	1	< 0.1%
887	1	< 0.1%
835	1	< 0.1%
827	1	< 0.1%
750	1	< 0.1%

SO2
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	247
Distinct (%)	0.7%
Missing	980
Missing (%)	2.8%
Infinite	0
Infinite (%)	0.0%
Mean	12.121553

Minimum	0.2856
Maximum	315
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	0.2856
5-th percentile	2
Q1	2
median	4
Q3	14
95-th percentile	49
Maximum	315
Range	314.7144
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	18.896912
Coefficient of variation (CV)	1.5589514
Kurtosis	21.886752
Mean	12.121553
Median Absolute Deviation (MAD)	2
Skewness	3.7248776
Sum	413151.01
Variance	357.09327
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	11723	33.4%
3	3558	10.1%
4	1814	5.2%
5	1449	4.1%
6	1286	3.7%
7	1022	2.9%
8	879	2.5%
9	765	2.2%
10	673	1.9%
11	618	1.8%
Other values (237)	10297	29.4%
(Missing)	980	2.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2856	18	0.1%
0.5712	5	< 0.1%
0.8568	2	< 0.1%
1	469	1.3%
1.1424	2	< 0.1%
1.428	6	< 0.1%
1.7136	1	< 0.1%
1.9992	3	< 0.1%
2	11723	33.4%
2.2848	2	< 0.1%

Value	Count	Frequency (%)
315	1	< 0.1%
314	1	< 0.1%
268	1	< 0.1%
254	1	< 0.1%
253	1	< 0.1%
224	1	< 0.1%
219	1	< 0.1%
216	1	< 0.1%
196	1	< 0.1%
193	2	< 0.1%

NO2
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	296
Distinct (%)	0.9%
Missing	1639
Missing (%)	4.7%
Infinite	0
Infinite (%)	0.0%
Mean	32.49725

Minimum	1.0265
Maximum	231
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	1.0265
5-th percentile	4
Q1	12
median	25
Q3	46
95-th percentile	85
Maximum	231
Range	229.9735
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	26.489531
Coefficient of variation (CV)	0.81513146
Kurtosis	2.3878609
Mean	32.49725
Median Absolute Deviation (MAD)	15
Skewness	1.3853616
Sum	1086220.6
Variance	701.69525
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	1036	3.0%
11	796	2.3%
6	796	2.3%
8	795	2.3%
12	777	2.2%
10	772	2.2%
14	769	2.2%
9	767	2.2%
7	761	2.2%
13	747	2.1%
Other values (286)	25409	72.5%
(Missing)	1639	4.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.0265	2	< 0.1%
1.4371	1	< 0.1%
1.6424	2	< 0.1%
2	1036	3.0%
2.053	1	< 0.1%
2.2583	1	< 0.1%
2.6689	1	< 0.1%
3	555	1.6%
3.4901	1	< 0.1%
4	678	1.9%

Value	Count	Frequency (%)
231	1	< 0.1%
219	1	< 0.1%
205	1	< 0.1%
199	1	< 0.1%
198	1	< 0.1%
195	1	< 0.1%
189	1	< 0.1%
184	1	< 0.1%
183	1	< 0.1%
180	1	< 0.1%

CO
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	108
Distinct (%)	0.3%
Missing	1422
Missing (%)	4.1%
Infinite	0
Infinite (%)	0.0%
Mean	1022.5545

Minimum	100
Maximum	10000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	100
5-th percentile	200
Q1	400
median	800
Q3	1300
95-th percentile	2600
Maximum	10000
Range	9900
Interquartile range (IQR)	900

Descriptive statistics

Standard deviation	898.73824
Coefficient of variation (CV)	0.87891472
Kurtosis	14.626095
Mean	1022.5545
Median Absolute Deviation (MAD)	400
Skewness	2.8775555
Sum	34400780
Variance	807730.43
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300	3255	9.3%
400	2921	8.3%
500	2697	7.7%
200	2386	6.8%
600	2269	6.5%
700	2223	6.3%
900	1857	5.3%
800	1842	5.3%
1000	1731	4.9%
1100	1467	4.2%
Other values (98)	10994	31.4%
(Missing)	1422	4.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100	545	1.6%
200	2386	6.8%
300	3255	9.3%
400	2921	8.3%
500	2697	7.7%
600	2269	6.5%
700	2223	6.3%
800	1842	5.3%
900	1857	5.3%
1000	1731	4.9%

Value	Count	Frequency (%)
10000	3	< 0.1%
9800	2	< 0.1%
9700	1	< 0.1%
9600	1	< 0.1%
9300	3	< 0.1%
9200	1	< 0.1%
9000	5	< 0.1%
8900	1	< 0.1%
8800	2	< 0.1%
8700	4	< 0.1%

O3
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	812
Distinct (%)	2.4%
Missing	1151
Missing (%)	3.3%
Infinite	0
Infinite (%)	0.0%
Mean	59.824713

Minimum	0.2142
Maximum	444
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	0.2142
5-th percentile	2
Q1	18
median	49
Q3	83
95-th percentile	173
Maximum	444
Range	443.7858
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	54.605746
Coefficient of variation (CV)	0.91276236
Kurtosis	3.3599719
Mean	59.824713
Median Absolute Deviation (MAD)	32
Skewness	1.5929856
Sum	2028835.5
Variance	2981.7875
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	3300	9.4%
4	322	0.9%
16	315	0.9%
12	313	0.9%
3	307	0.9%
14	304	0.9%
64	304	0.9%
58	302	0.9%
18	301	0.9%
6	300	0.9%
Other values (802)	27845	79.4%
(Missing)	1151	3.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2142	7	< 0.1%
0.4284	7	< 0.1%
0.6426	4	< 0.1%
0.8568	9	< 0.1%
1	167	0.5%
1.071	7	< 0.1%
1.2852	12	< 0.1%
1.4994	9	< 0.1%
1.7136	8	< 0.1%
1.9278	10	< 0.1%

Value	Count	Frequency (%)
444	1	< 0.1%
413	1	< 0.1%
391	1	< 0.1%
386	1	< 0.1%
385	1	< 0.1%
379	2	< 0.1%
374	1	< 0.1%
371	1	< 0.1%
367	1	< 0.1%
364	1	< 0.1%

TEMP
Real number (ℝ)

HIGH CORRELATION

Distinct	1012
Distinct (%)	2.9%
Missing	51
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	12.445426

Minimum	-19.9
Maximum	40.3
Zeros	191
Zeros (%)	0.5%
Negative	6684
Negative (%)	19.1%
Memory size	274.1 KiB

Quantile statistics

Minimum	-19.9
5-th percentile	-6.3
Q1	2.1
median	13.6
Q3	22.3
95-th percentile	30
Maximum	40.3
Range	60.2
Interquartile range (IQR)	20.2

Descriptive statistics

Standard deviation	11.751103
Coefficient of variation (CV)	0.94421062
Kurtosis	-1.0877016
Mean	12.445426
Median Absolute Deviation (MAD)	9.9
Skewness	-0.14170269
Sum	435751.69
Variance	138.08842
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	204	0.6%
0	191	0.5%
-1	177	0.5%
-2	175	0.5%
2	165	0.5%
1	161	0.5%
-4	156	0.4%
21.8	140	0.4%
-5	139	0.4%
19.3	136	0.4%
Other values (1002)	33369	95.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-19.9	1	< 0.1%
-19.7	1	< 0.1%
-19.5	1	< 0.1%
-18.9	1	< 0.1%
-18.7	1	< 0.1%
-18.5	1	< 0.1%
-18.1	1	< 0.1%
-17.9	1	< 0.1%
-17.4	1	< 0.1%
-17.3	1	< 0.1%

Value	Count	Frequency (%)
40.3	1	< 0.1%
39	1	< 0.1%
38.9	1	< 0.1%
38.8	1	< 0.1%
38.7	2	< 0.1%
38.6	1	< 0.1%
38.5	2	< 0.1%
38.3	1	< 0.1%
38.2	1	< 0.1%
37.9	1	< 0.1%

PRES
Real number (ℝ)

HIGH CORRELATION

Distinct	589
Distinct (%)	1.7%
Missing	53
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	1007.5986

Minimum	982.8
Maximum	1036.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	982.8
5-th percentile	992.4
Q1	999.3
median	1007.3
Q3	1015.5
95-th percentile	1024
Maximum	1036.5
Range	53.7
Interquartile range (IQR)	16.2

Descriptive statistics

Standard deviation	10.022101
Coefficient of variation (CV)	0.0099465216
Kurtosis	-0.86019444
Mean	1007.5986
Median Absolute Deviation (MAD)	8.1
Skewness	0.11179248
Sum	35277033
Variance	100.44251
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1012	271	0.8%
1015	263	0.8%
1011	263	0.8%
1016	262	0.7%
1014	256	0.7%
1013	248	0.7%
1018	247	0.7%
1008	229	0.7%
1009	226	0.6%
1010	222	0.6%
Other values (579)	32524	92.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
982.8	1	< 0.1%
983	2	< 0.1%
983.3	1	< 0.1%
983.4	2	< 0.1%
983.5	2	< 0.1%
983.6	4	< 0.1%
983.8	2	< 0.1%
984	2	< 0.1%
984.1	1	< 0.1%
984.2	2	< 0.1%

Value	Count	Frequency (%)
1036.5	1	< 0.1%
1036.4	1	< 0.1%
1036	1	< 0.1%
1035.9	1	< 0.1%
1035.7	2	< 0.1%
1035.6	1	< 0.1%
1035.5	2	< 0.1%
1035.4	2	< 0.1%
1035.3	4	< 0.1%
1035.1	2	< 0.1%

DEWP
Real number (ℝ)

HIGH CORRELATION

Distinct	617
Distinct (%)	1.8%
Missing	53
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	2.2386193

Minimum	-43.4
Maximum	29.1
Zeros	73
Zeros (%)	0.2%
Negative	15770
Negative (%)	45.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	-43.4
5-th percentile	-20
Q1	-9.6
median	2.7
Q3	15.3
95-th percentile	22.3
Maximum	29.1
Range	72.5
Interquartile range (IQR)	24.9

Descriptive statistics

Standard deviation	14.052541
Coefficient of variation (CV)	6.2773252
Kurtosis	-1.1891197
Mean	2.2386193
Median Absolute Deviation (MAD)	12.5
Skewness	-0.15275562
Sum	78376.3
Variance	197.47392
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.2	155	0.4%
17	148	0.4%
17.2	137	0.4%
17.7	129	0.4%
17.1	127	0.4%
17.9	126	0.4%
17.6	124	0.4%
17.4	124	0.4%
18.1	123	0.4%
17.8	122	0.3%
Other values (607)	33696	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-43.4	1	< 0.1%
-34.9	1	< 0.1%
-34.5	3	< 0.1%
-34.4	1	< 0.1%
-34	1	< 0.1%
-33.8	3	< 0.1%
-33.6	1	< 0.1%
-33.5	1	< 0.1%
-33.4	1	< 0.1%
-33.1	1	< 0.1%

Value	Count	Frequency (%)
29.1	2	< 0.1%
29	1	< 0.1%
28.8	4	< 0.1%
28.7	3	< 0.1%
28.6	2	< 0.1%
28.5	2	< 0.1%
28.4	2	< 0.1%
28.3	7	< 0.1%
28	1	< 0.1%
27.9	2	< 0.1%

RAIN
Real number (ℝ)

SKEWED ZEROS

Distinct	128
Distinct (%)	0.4%
Missing	55
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.067939673

Minimum	0
Maximum	45.9
Zeros	33518
Zeros (%)	95.6%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	45.9
Range	45.9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.84904633
Coefficient of variation (CV)	12.497062
Kurtosis	950.19101
Mean	0.067939673
Median Absolute Deviation (MAD)	0
Skewness	26.543233
Sum	2378.5
Variance	0.72087967
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33518	95.6%
0.1	384	1.1%
0.2	163	0.5%
0.3	119	0.3%
0.4	91	0.3%
0.7	61	0.2%
0.5	57	0.2%
0.6	55	0.2%
0.8	54	0.2%
1	41	0.1%
Other values (118)	466	1.3%
(Missing)	55	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33518	95.6%
0.1	384	1.1%
0.2	163	0.5%
0.3	119	0.3%
0.4	91	0.3%
0.5	57	0.2%
0.6	55	0.2%
0.7	61	0.2%
0.8	54	0.2%
0.9	41	0.1%

Value	Count	Frequency (%)
45.9	2	< 0.1%
36.1	1	< 0.1%
30.9	1	< 0.1%
28.1	1	< 0.1%
28	1	< 0.1%
26.7	1	< 0.1%
25	1	< 0.1%
24.3	1	< 0.1%
23.2	1	< 0.1%
22.7	1	< 0.1%

wd
Categorical

Distinct	16
Distinct (%)	< 0.1%
Missing	302
Missing (%)	0.9%
Memory size	274.1 KiB

NW	4943
WNW	4876
NE	2252
E	2159
W	2138
Other values (11)	18394

Length

Max length	3
Median length	2
Mean length	2.2782636
Min length	1

Characters and Unicode

Total characters	79197
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WNW
2nd row	NNW
3rd row	NW
4th row	NNW
5th row	NNW

Common Values

Value	Count	Frequency (%)
NW	4943	14.1%
WNW	4876	13.9%
NE	2252	6.4%
E	2159	6.2%
W	2138	6.1%
SE	2113	6.0%
ENE	2026	5.8%
ESE	2022	5.8%
SW	1797	5.1%
NNE	1687	4.8%
Other values (6)	8749	25.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nw	4943	14.2%
wnw	4876	14.0%
ne	2252	6.5%
e	2159	6.2%
w	2138	6.2%
se	2113	6.1%
ene	2026	5.8%
ese	2022	5.8%
sw	1797	5.2%
nne	1687	4.9%
Other values (6)	8749	25.2%

Most occurring characters

Value	Count	Frequency (%)
W	24579	31.0%
N	22164	28.0%
E	17880	22.6%
S	14574	18.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	79197	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
W	24579	31.0%
N	22164	28.0%
E	17880	22.6%
S	14574	18.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	79197	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
W	24579	31.0%
N	22164	28.0%
E	17880	22.6%
S	14574	18.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	79197	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
W	24579	31.0%
N	22164	28.0%
E	17880	22.6%
S	14574	18.4%

WSPM
Real number (ℝ)

Distinct	105
Distinct (%)	0.3%
Missing	49
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.6520206

Minimum	0
Maximum	12.9
Zeros	150
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.5
Q1	0.9
median	1.3
Q3	2
95-th percentile	4.1
Maximum	12.9
Range	12.9
Interquartile range (IQR)	1.1

Descriptive statistics

Standard deviation	1.1991431
Coefficient of variation (CV)	0.72586449
Kurtosis	6.7199394
Mean	1.6520206
Median Absolute Deviation (MAD)	0.5
Skewness	2.1770809
Sum	57845.5
Variance	1.4379441
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2205	6.3%
0.9	2204	6.3%
0.8	2192	6.3%
0.7	2024	5.8%
1.1	2011	5.7%
1.2	1881	5.4%
1.3	1764	5.0%
0.6	1573	4.5%
1.4	1542	4.4%
1.5	1396	4.0%
Other values (95)	16223	46.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	150	0.4%
0.1	118	0.3%
0.2	148	0.4%
0.3	199	0.6%
0.4	484	1.4%
0.5	1284	3.7%
0.6	1573	4.5%
0.7	2024	5.8%
0.8	2192	6.3%
0.9	2204	6.3%

Value	Count	Frequency (%)
12.9	1	< 0.1%
11.8	1	< 0.1%
11.7	1	< 0.1%
11	1	< 0.1%
10.9	2	< 0.1%
10.4	1	< 0.1%
10.1	1	< 0.1%
10	1	< 0.1%
9.9	1	< 0.1%
9.7	2	< 0.1%

station
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	274.1 KiB

Huairou	35064

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	245448
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Huairou
2nd row	Huairou
3rd row	Huairou
4th row	Huairou
5th row	Huairou

Common Values

Value	Count	Frequency (%)
Huairou	35064	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
huairou	35064	100.0%

Most occurring characters

Value	Count	Frequency (%)
u	70128	28.6%
H	35064	14.3%
a	35064	14.3%
i	35064	14.3%
r	35064	14.3%
o	35064	14.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	210384	85.7%
Uppercase Letter	35064	14.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	70128	33.3%
a	35064	16.7%
i	35064	16.7%
r	35064	16.7%
o	35064	16.7%

Uppercase Letter

Value	Count	Frequency (%)
H	35064	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	245448	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	70128	28.6%
H	35064	14.3%
a	35064	14.3%
i	35064	14.3%
r	35064	14.3%
o	35064	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	245448	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
u	70128	28.6%
H	35064	14.3%
a	35064	14.3%
i	35064	14.3%
r	35064	14.3%
o	35064	14.3%

Auto

Heatmap
Table

	CO	DEWP	NO2	No	O3	PM10	PM2.5	PRES	RAIN	SO2	TEMP	WSPM	day	hour	month	wd	year
CO	1.000	0.101	0.739	-0.059	-0.371	0.755	0.851	0.082	0.027	0.544	-0.185	-0.338	0.003	0.014	0.023	0.040	0.075
DEWP	0.101	1.000	-0.127	-0.088	0.231	0.187	0.224	-0.769	0.180	-0.267	0.815	-0.219	0.023	-0.014	0.255	0.064	0.149
NO2	0.739	-0.127	1.000	-0.145	-0.461	0.671	0.680	0.225	-0.083	0.624	-0.314	-0.301	0.022	0.100	-0.009	0.046	0.096
No	-0.059	-0.088	-0.145	1.000	-0.135	-0.106	-0.074	0.166	0.013	-0.280	-0.120	0.115	0.018	0.001	0.044	0.081	0.862
O3	-0.371	0.231	-0.461	-0.135	1.000	-0.107	-0.182	-0.420	-0.030	-0.080	0.563	0.381	0.005	0.242	-0.139	0.104	0.064
PM10	0.755	0.187	0.671	-0.106	-0.107	1.000	0.904	-0.118	-0.054	0.510	0.051	-0.186	0.026	0.114	-0.061	0.041	0.059
PM2.5	0.851	0.224	0.680	-0.074	-0.182	0.904	1.000	-0.072	-0.010	0.504	0.000	-0.273	0.014	0.038	-0.029	0.035	0.053
PRES	0.082	-0.769	0.225	0.166	-0.420	-0.118	-0.072	1.000	-0.085	0.204	-0.827	-0.018	0.017	-0.038	-0.016	0.055	0.146
RAIN	0.027	0.180	-0.083	0.013	-0.030	-0.054	-0.010	-0.085	1.000	-0.135	0.047	-0.030	-0.005	-0.005	0.049	0.011	0.000
SO2	0.544	-0.267	0.624	-0.280	-0.080	0.510	0.504	0.204	-0.135	1.000	-0.233	-0.061	0.012	0.124	-0.197	0.041	0.114
TEMP	-0.185	0.815	-0.314	-0.120	0.563	0.051	0.000	-0.827	0.047	-0.233	1.000	0.124	0.017	0.150	0.123	0.107	0.145
WSPM	-0.338	-0.219	-0.301	0.115	0.381	-0.186	-0.273	-0.018	-0.030	-0.061	0.124	1.000	-0.002	0.168	-0.148	0.080	0.078
day	0.003	0.023	0.022	0.018	0.005	0.026	0.014	0.017	-0.005	0.012	0.017	-0.002	1.000	0.000	0.010	0.021	0.000
hour	0.014	-0.014	0.100	0.001	0.242	0.114	0.038	-0.038	-0.005	0.124	0.150	0.168	0.000	1.000	0.000	0.167	0.000
month	0.023	0.255	-0.009	0.044	-0.139	-0.061	-0.029	-0.016	0.049	-0.197	0.123	-0.148	0.010	0.000	1.000	0.068	0.249
wd	0.040	0.064	0.046	0.081	0.104	0.041	0.035	0.055	0.011	0.041	0.107	0.080	0.021	0.167	0.068	1.000	0.097
year	0.075	0.149	0.096	0.862	0.064	0.059	0.053	0.146	0.000	0.114	0.145	0.078	0.000	0.000	0.249	0.097	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	No	year	month	day	hour	PM2.5	PM10	SO2	NO2	CO	O3	TEMP	PRES	DEWP	wd	WSPM	station
0	1	2013	3	1	0	7.0	7.0	3.0	2.0	100.0	91.0	-2.3	1020.3	-20.7	WNW	3.1	Huairou
1	2	2013	3	1	1	4.0	4.0	3.0	NaN	100.0	92.0	-2.7	1020.8	-20.5	NNW	1.5	Huairou
2	3	2013	3	1	2	4.0	4.0	NaN	NaN	100.0	91.0	-3.2	1020.6	-21.4	NW	1.8	Huairou
3	4	2013	3	1	3	3.0	3.0	3.0	2.0	NaN	NaN	-3.3	1021.3	-23.7	NNW	2.4	Huairou
4	5	2013	3	1	4	3.0	3.0	7.0	NaN	300.0	86.0	-4.1	1022.1	-22.7	NNW	2.2	Huairou
5	6	2013	3	1	5	4.0	4.0	3.0	3.0	200.0	85.0	-4.2	1022.3	-24.5	N	4.3	Huairou
6	7	2013	3	1	6	3.0	6.0	33.0	7.0	300.0	82.0	-5.9	1023.1	-21.9	WNW	0.6	Huairou
7	8	2013	3	1	7	3.0	10.0	13.0	13.0	400.0	71.0	-2.7	1024.3	-23.2	NNE	3.4	Huairou
8	9	2013	3	1	8	3.0	13.0	34.0	38.0	800.0	45.0	-1.6	1025.2	-23.5	NNE	4.6	Huairou
9	10	2013	3	1	9	17.0	36.0	50.0	28.0	700.0	60.0	-1.1	1025.4	-23.8	NE	4.9	Huairou

	No	year	month	day	hour	PM2.5	PM10	SO2	NO2	CO	O3	TEMP	PRES	DEWP	wd	WSPM	station
35054	35055	2017	2	28	14	7.0	7.0	2.0	6.0	100.0	112.0	15.0	1007.9	-12.3	WNW	4.6	Huairou
35055	35056	2017	2	28	15	8.0	8.0	2.0	6.0	200.0	114.0	15.0	1007.3	-12.3	W	4.2	Huairou
35056	35057	2017	2	28	16	9.0	18.0	2.0	7.0	200.0	114.0	15.8	1006.9	-12.6	WNW	3.7	Huairou
35057	35058	2017	2	28	17	9.0	11.0	2.0	6.0	100.0	116.0	14.9	1007.0	-14.3	NW	2.0	Huairou
35058	35059	2017	2	28	18	9.0	18.0	2.0	10.0	200.0	109.0	13.0	1007.7	-14.8	NNW	2.7	Huairou
35059	35060	2017	2	28	19	16.0	28.0	2.0	19.0	300.0	95.0	9.9	1008.6	-14.1	WNW	1.8	Huairou
35060	35061	2017	2	28	20	21.0	34.0	4.0	24.0	500.0	80.0	9.5	1008.9	-14.4	SSW	1.3	Huairou
35061	35062	2017	2	28	21	17.0	33.0	2.0	39.0	900.0	60.0	8.4	1009.3	-14.6	SE	1.5	Huairou
35062	35063	2017	2	28	22	11.0	29.0	3.0	32.0	1400.0	69.0	8.3	1009.5	-14.7	ENE	3.2	Huairou
35063	35064	2017	2	28	23	11.0	20.0	2.0	27.0	400.0	77.0	6.7	1009.3	-13.6	NE	1.9	Huairou

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample